<?php defined('SYSPATH') or die('No direct script access.');
/**
 * $Id: database.php 50 2008-07-27 09:06:29Z geertdd $
 *
 * @package    PianissiBoard
 * @author     Geert De Deckere
 */

/**
 * Database connection settings
 */
$config['default'] = array
(
	'benchmark'     => ! IN_PRODUCTION,
	'persistent'    => FALSE,
	'connection'    => array
	(
		'type'      => 'mysqli',
		'user'      => 'demo_user',
		'pass'      => 'demo_pass',
		'host'      => 'localhost',
		'port'      => FALSE,
		'socket'    => FALSE,
		'database'  => 'pianissiboard'
	),
	'character_set' => 'utf8',
	'table_prefix'  => '',
	'object'        => TRUE,
	'cache'         => FALSE,
	'escape'        => TRUE
);

/*

CREATE TABLE `pianissiboard_topics` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `slug` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `sticky` tinyint(1) unsigned NOT NULL default '0',
  `closed` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

CREATE TABLE `pianissiboard_posts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `topic_id` int(10) unsigned NOT NULL default '0',
  `post` text collate utf8_unicode_ci NOT NULL,
  `author` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `email` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `website` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;

*/